SyServiceProcess 
Logical Entity Name  SyServiceProcess 
Default Table Name  SyServiceProcess 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

SyServiceProcess Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SyServiceProcessId(PK)    int  NO 
 
SyServiceProcessTypeId(FK)    int  NO 
 
Code    char(8)  NO 
 
Descrip    varchar(50)  NO 
 
Active    bit  NO 
 
Module    varchar(50)  NO 
 
WebServiceEndPoint    nvarchar(1000)  YES 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
ProcessInfoType    int  NO 
 
IsExceptionMgmtReady    bit  NO 
 

SyServiceProcess Primary and Unique Keys 
Key Name  Key Type  Keys 
Uk_SyServiceProcessCode  Index  Code 
Pk_SyServiceProcess_SyServiceProcessID  PrimaryKey  SyServiceProcessId 

SyServiceProcess Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyServiceProcessType  Non-Identifying  One To Zero or More  FK_SyServiceProcessSyServiceProcessTypeId_SyServiceProcessTypeSyServiceProcessTypeId      SyServiceProcessTypeId  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  Fk_SyServiceProcessUserID_SyStaffSyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
SyAutomatedProcessActivation  Non-Identifying  One To Zero or More  FK_SyAutomatedProcessActivationSyServiceProcessID_SyServiceProcessSyServiceProcessID        NO  YES 
SyEventSinkSubscription  Non-Identifying  One To Zero or More  FK_SyEventSinkSubscriptionSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceExceptionTemplate  Non-Identifying  One To Zero or More  FK_SyServiceExceptionTemplateSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceProcessExportImportMapping  Non-Identifying  One To Zero or More  FK_SyServiceProcessExportImportMapping_SyServiceProcess_SyServiceProcessID_Exp        NO  YES 
SyServiceProcessExportImportMapping  Non-Identifying  One To Zero or More  FK_SyServiceProcessExportImportMapping_SyServiceProcess_SyServiceProcessID_Imp        NO  YES 
SyServiceProcessExportMaster  Non-Identifying  One To Zero or More  FK_SyServiceProcessExportMaster_SyServiceProcessID_SyServiceProcess_SyServiceProcessId        NO  YES 
SyServiceProcessImportMaster  Non-Identifying  One To Zero or More  FK_SyServiceProcessImportMasterSyServiceProcessID_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceProcessMapping  Non-Identifying  One To Zero or More  FK_SyServiceProcessMappingSyServiceProcessID_SyServiceProcessSyServiceProcessID        NO  YES 
SyServiceProcessSubscription  Non-Identifying  One To Zero or More  Fk_SyServiceProcessSubscriptionSyServiceProcessID_SyServiceProcessSyServiceProcessID        NO  YES 
SyServiceRequest  Non-Identifying  One To Zero or More  FK_SyServiceRequestSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceStarRequestQueue  Non-Identifying  One To Zero or More  FK_SyServiceStarRequestQueueSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceSubscriptionExceptionRoutingRelationship  Non-Identifying  One To Zero or More  FK_SyServiceSubscriptionExceptionRoutingRelationshipSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceSubscriptionNotificationRelationship  Non-Identifying  One To Zero or More  FK_SyServiceSubscriptionNotificationRelationshipSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 

SyServiceProcess Check Constraints 
Check Constraint Name  CheckConstraint 

SyServiceProcess Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

SyServiceProcess Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.BusinessProcess 
NO       
Physical (Microsoft SQL Server)
dbo.SyServiceProcess 
NO       

SyServiceProcess Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Service 
Physical (Microsoft SQL Server)  System 

SyServiceProcess Data Movement Rules 
Name  Type  Rule Text/Value